DROP TABLE demo;
CREATE TABLE demo(
  id number(4) PRIMARY KEY ,
  name varchar(20),
  s NUMBER(4),
  ss NUMBER(4),
  b NUMBER(4),
  bb NUMBER(4),
  l NUMBER(4),
  ll NUMBER(4),
  f BINARY_FLOAT,
  ff BINARY_FLOAT,
  d BINARY_DOUBLE,
  dd BINARY_DOUBLE,
  bo NUMBER(1),
  bbo NUMBER(1),
  big NUMBER(10,2),
  localDate DATE,
  localTime DATE,
  localDateTime TIMESTAMP,
  ddd TIMESTAMP,
  integers VARCHAR2(32),
  shorts VARCHAR2(32),
  bytes VARCHAR2(32),
  longs VARCHAR2(32),
  floats VARCHAR2(32),
  doubles VARCHAR2(32),
  booleans VARCHAR2(32),
  bigDecimals VARCHAR2(32),
  localDates VARCHAR2(32),
  localTimes VARCHAR2(32),
  localDateTimes VARCHAR2(64),
  dates VARCHAR2(64)
);
INSERT INTO demo (id, name, s, ss, b, bb, l, ll, f, ff, d, dd, bo, bbo, big, localDate, localTime, localDateTime, ddd, integers, shorts, bytes, longs, floats, doubles, booleans, bigDecimals, localDates, localTimes, localDateTimes, dates)
    VALUES (1,'张三',2,2,3,3,4,4,5.0f,5.0f,6.0d,6.0d,1,1,7.8,sysdate,sysdate,systimestamp,sysdate,'1,2','3,4','5,6','7,8','9.1,9.2','10.3,10.4','true,false,true','11.54,12.45','2017-10-12,2017-12-03','10:33:40,11:10:00','2017-10-12 10:33:40,2017-12-03 11:10:00','2017-10-12 10:33:40,2017-12-03 11:10:00');
INSERT INTO demo (id, name, s, ss, b, bb, l, ll, f, ff, d, dd, bo, bbo, big, localDate, localTime, localDateTime, ddd, integers, shorts, bytes, longs, floats, doubles, booleans, bigDecimals, localDates, localTimes, localDateTimes, dates)
  VALUES (2,'李四',2,NULL,3,NULL,4,NULL,5.0f,NULL,6.0d,NULL,1,NULL,7.8,sysdate,sysdate,systimestamp,sysdate,NULL,'3,4','5,6','7,8','9.1,9.2','10.3,10.4','true,false,true','11.54,12.45','2017-10-12,2017-12-03','10:33:40,11:10:00','2017-10-12 10:33:40,2017-12-03 11:10:00','2017-10-12 10:33:40,2017-12-03 11:10:00');